﻿-- =============================================
-- Author:		<Author,,Name>
-- Create date: <Create Date,,>
-- Description:	审批扣款申请
-- =============================================
create PROCEDURE [dbo].[proc_Employee_Deduction_Audit]
	(
	@id int,
	@flag int,
	@UserName nvarchar(50),
	@UserId varchar(50),
	@FirstMemo nvarchar(500)
	)
AS
BEGIN
	update [Employee_Deduction]   
     
      set [flag]=@flag
    
      ,[FirstAuditPerson]=@UserId
      ,[FirstAuditPersonName]=@UserName
      ,[FirstAuditDate]=getdate()
      ,[FirstMemo]=@FirstMemo
  
     where id=@id
  
END
